Tabela ExternalServiceResource

Definicja tabeli ExternalServiceResource

Name

ExternalServiceResource

Code

ExternalServiceResource

Comment

 


Lista kolumn tabeli ExternalServiceResource

Name

Code

ExternalServiceResourceID

ExternalServiceResourceID

EventID

EventID

ServID

ServID

UnitID

UnitID

ShortName

ShortName

FullName

FullName

Description

Description

Comments

Comments

UnitsCount

UnitsCount

PerNoOfUnits

PerNoOfUnits

NCPersonel

NCPersonel

UCMaterials

UCMaterials

UCDrugs

UCDrugs

UCOther

UCOther


Kolumna ExternalServiceResourceID tabeli ExternalServiceResource

Definicja kolumny ExternalServiceResourceID tabeli ExternalServiceResource

Name

ExternalServiceResourceID

Code

ExternalServiceResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna EventID tabeli ExternalServiceResource

Definicja kolumny EventID tabeli ExternalServiceResource

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ServID tabeli ExternalServiceResource

Definicja kolumny ServID tabeli ExternalServiceResource

Name

ServID

Code

ServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UnitID tabeli ExternalServiceResource

Definicja kolumny UnitID tabeli ExternalServiceResource

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ShortName tabeli ExternalServiceResource

Definicja kolumny ShortName tabeli ExternalServiceResource

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

PL: Skrócona nazwa wiersza
EN: Record's short name
DE: Der kurz Name des Rekord


Kolumna FullName tabeli ExternalServiceResource

Definicja kolumny FullName tabeli ExternalServiceResource

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

PL: Pelna nazwa wiersza
EN: Record's full name
DE: Der voll Name des Rekord


Kolumna Description tabeli ExternalServiceResource

Definicja kolumny Description tabeli ExternalServiceResource

Name

Description

Code

Description

Data Type

VARCHAR2(48)

Mandatory

No

Comment

PL: Opis wiersza
EN: Record's description
DE: Die Beschreibung des Rekord


Kolumna Comments tabeli ExternalServiceResource

Definicja kolumny Comments tabeli ExternalServiceResource

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna UnitsCount tabeli ExternalServiceResource

Definicja kolumny UnitsCount tabeli ExternalServiceResource

Name

UnitsCount

Code

UnitsCount

Data Type

NUMBER(12,6)

Mandatory

No

Comment

 


Kolumna PerNoOfUnits tabeli ExternalServiceResource

Definicja kolumny PerNoOfUnits tabeli ExternalServiceResource

Name

PerNoOfUnits

Code

PerNoOfUnits

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NCPersonel tabeli ExternalServiceResource

Definicja kolumny NCPersonel tabeli ExternalServiceResource

Name

NCPersonel

Code

NCPersonel

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UCMaterials tabeli ExternalServiceResource

Definicja kolumny UCMaterials tabeli ExternalServiceResource

Name

UCMaterials

Code

UCMaterials

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UCDrugs tabeli ExternalServiceResource

Definicja kolumny UCDrugs tabeli ExternalServiceResource

Name

UCDrugs

Code

UCDrugs

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Kolumna UCOther tabeli ExternalServiceResource

Definicja kolumny UCOther tabeli ExternalServiceResource

Name

UCOther

Code

UCOther

Data Type

NUMBER(10,2)

Mandatory

No

Comment

 


Lista kluczy tabeli ExternalServiceResource

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExternalServiceResource

Definicja klucza Identifier_1 tabeli ExternalServiceResource

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment